| LendingInstitution |
| EntityType | Independent |
| Logical Entity Name | LendingInstitution |
| Default Table Name | FaLender |
| Logical Only | NO |
| Definition | |
| Note |
| LendingInstitution Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
| Code | VARCHAR(16) | NO | ||
| Name | VARCHAR(50) | NO | ||
| IsLender | BIT | NO | ||
| IsServicer | BIT | NO | ||
| IsGuarantor | BIT | NO | ||
| IsDirectLoans | BIT | NO | ||
| LenderIdentifier | CHAR(6) | YES | ||
| DefaultServicerCode | CHAR(8) | YES | ||
| DefaultGuarantorCode | CHAR(8) | YES | ||
| FeeAmount1 | NUMERIC(9, 6) | YES | ||
| FeeType1 | CHAR(1) | YES | ||
| FeeDescription1 | VARCHAR(50) | YES | ||
| FeeAmount2 | NUMERIC(9, 6) | YES | ||
| FeeType2 | CHAR(1) | YES | ||
| FeeDescription2 | VARCHAR(50) | YES | ||
| StreetAddress | VARCHAR(255) | YES | ||
| StreetAddress2 | VARCHAR(35) | YES | ||
| City | VARCHAR(25) | YES | ||
| State | CHAR(2) | YES | ||
| PostalCode | CHAR(10) | YES | ||
| Country | VARCHAR(20) | YES | ||
| PaymentStreetAddress1 | VARCHAR(255) | YES | ||
| PaymentStreetAddress2 | VARCHAR(35) | YES | ||
| PaymentCity | VARCHAR(25) | YES | ||
| PaymentState | CHAR(2) | YES | ||
| PaymentPostalCode | CHAR(10) | YES | ||
| PaymentCountry | VARCHAR(20) | YES | ||
| PhoneNumber | CHAR(16) | YES | ||
| PhoneNumber2 | CHAR(16) | YES | ||
| FaxNumber | CHAR(16) | YES | ||
| CustomerServicePhoneNumber | CHAR(16) | YES | ||
| PreClaimsPhoneNumber | CHAR(16) | YES | ||
| PostClaimsPhoneNumber | CHAR(16) | YES | ||
| EmailAddress | VARCHAR(50) | YES | ||
| Contact1Name | VARCHAR(25) | YES | ||
| Contact2Name | VARCHAR(25) | YES | ||
| BusinessHours | VARCHAR(25) | YES | ||
| Note | TEXT | YES | ||
| FirstInterestRate | NUMERIC(9, 6) | YES | ||
| FirstInterestRateDescription | CHAR(30) | YES | ||
| SecondInterestRate | NUMERIC(9, 6) | YES | ||
| SecondInterestRateDescription | CHAR(30) | YES | ||
| IsActive | BIT | NO | ||
| LastModifiedUserId | INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| GuarantorIdentifier | CHAR(3) | YES | ||
| LenderNonEdBranchIdentifier | CHAR(4) | YES | ||
| IsCommonlineRecipient | BIT | NO | ||
| PaymentCountryId | INTEGER | YES | ||
| CountryId | INTEGER | YES | ||
| IsCommonLineRefundsSent | BIT | NO | ||
| DefaultRepaymentInterestRate | NUMERIC(9, 6) | YES | ||
| DefaultRepaymentNumberPayments | INTEGER | YES | ||
| DefaultReturnMethod | CHAR(1) | YES | ||
OrganizationId |
INTEGER | YES |
| LendingInstitution Keys |
| Key Name | Key Type | Keys |
| FaLender_FaLenderID_U_C_IDX | PrimaryKey | Id |
| Nk_FaLender_SyNexusOrganizationId | Inversion Entry | OrganizationId |
| LendingInstitution Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Organization | Non-Identifying | Zero or One to Zero or More | OrganizationId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FundSourceLendingInstitution | Non-Identifying | One To Zero or More | NO | ||||
| FundSourceLendingInstitution | Non-Identifying | One To Zero or More | NO | ||||
| FundSourceLendingInstitution | Non-Identifying | One To Zero or More | NO | ||||
| StudentAward | Non-Identifying | One To Zero or More | NO | ||||
| CodFundDrawdownReturnSource | Non-Identifying | One To Zero or More | NO |
| LendingInstitution Check Constraints |
| Check Constraint Name | CheckConstraint |